select 
	spr_works.myunp, spr_works.mykodf, spr_works.tabn, spr_works.fio, zarpl..spr_prof.naim
from
	spr_works
left join 
	zarpl..spr_prof on spr_works.profes = zarpl..spr_prof.profes
order by
	spr_works.fio